/*
 Navicat MySQL Data Transfer

 Source Server         : centos_liang
 Source Server Type    : MySQL
 Source Server Version : 50730
 Source Host           : centos_liang:3306
 Source Schema         : t2_z_com

 Target Server Type    : MySQL
 Target Server Version : 50730
 File Encoding         : 65001

 Date: 09/10/2020 19:50:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for area_city
-- ----------------------------
DROP TABLE IF EXISTS `area_city`;
CREATE TABLE `area_city` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增 id',
  `city_name` varchar(50) DEFAULT '' COMMENT '城市名称',
  `city_adcode` int(10) unsigned DEFAULT '0' COMMENT '城市行政区划代码',
  `province_adcode` int(10) unsigned DEFAULT '0' COMMENT '省份行政区划代码',
  `province_id` int(10) unsigned DEFAULT '0' COMMENT '省份 id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=512 DEFAULT CHARSET=utf8mb4 COMMENT='城市表';

-- ----------------------------
-- Records of area_city
-- ----------------------------
BEGIN;
INSERT INTO `area_city` VALUES (1, '北京市', 110100, 110000, 1);
INSERT INTO `area_city` VALUES (2, '天津市', 120100, 120000, 2);
INSERT INTO `area_city` VALUES (3, '石家庄市', 130100, 130000, 3);
INSERT INTO `area_city` VALUES (4, '唐山市', 130200, 130000, 3);
INSERT INTO `area_city` VALUES (5, '秦皇岛市', 130300, 130000, 3);
INSERT INTO `area_city` VALUES (6, '邯郸市', 130400, 130000, 3);
INSERT INTO `area_city` VALUES (7, '邢台市', 130500, 130000, 3);
INSERT INTO `area_city` VALUES (8, '保定市', 130600, 130000, 3);
INSERT INTO `area_city` VALUES (9, '张家口市', 130700, 130000, 3);
INSERT INTO `area_city` VALUES (10, '承德市', 130800, 130000, 3);
INSERT INTO `area_city` VALUES (11, '沧州市', 130900, 130000, 3);
INSERT INTO `area_city` VALUES (12, '廊坊市', 131000, 130000, 3);
INSERT INTO `area_city` VALUES (13, '衡水市', 131100, 130000, 3);
INSERT INTO `area_city` VALUES (14, '太原市', 140100, 140000, 4);
INSERT INTO `area_city` VALUES (15, '大同市', 140200, 140000, 4);
INSERT INTO `area_city` VALUES (16, '阳泉市', 140300, 140000, 4);
INSERT INTO `area_city` VALUES (17, '长治市', 140400, 140000, 4);
INSERT INTO `area_city` VALUES (18, '晋城市', 140500, 140000, 4);
INSERT INTO `area_city` VALUES (19, '朔州市', 140600, 140000, 4);
INSERT INTO `area_city` VALUES (20, '晋中市', 140700, 140000, 4);
INSERT INTO `area_city` VALUES (21, '运城市', 140800, 140000, 4);
INSERT INTO `area_city` VALUES (22, '忻州市', 140900, 140000, 4);
INSERT INTO `area_city` VALUES (23, '临汾市', 141000, 140000, 4);
INSERT INTO `area_city` VALUES (24, '吕梁市', 141100, 140000, 4);
INSERT INTO `area_city` VALUES (25, '呼和浩特市', 150100, 150000, 5);
INSERT INTO `area_city` VALUES (26, '包头市', 150200, 150000, 5);
INSERT INTO `area_city` VALUES (27, '乌海市', 150300, 150000, 5);
INSERT INTO `area_city` VALUES (28, '赤峰市', 150400, 150000, 5);
INSERT INTO `area_city` VALUES (29, '通辽市', 150500, 150000, 5);
INSERT INTO `area_city` VALUES (30, '鄂尔多斯市', 150600, 150000, 5);
INSERT INTO `area_city` VALUES (31, '呼伦贝尔市', 150700, 150000, 5);
INSERT INTO `area_city` VALUES (32, '巴彦淖尔市', 150800, 150000, 5);
INSERT INTO `area_city` VALUES (33, '乌兰察布市', 150900, 150000, 5);
INSERT INTO `area_city` VALUES (34, '兴安盟', 152200, 150000, 5);
INSERT INTO `area_city` VALUES (35, '锡林郭勒盟', 152500, 150000, 5);
INSERT INTO `area_city` VALUES (36, '阿拉善盟', 152900, 150000, 5);
INSERT INTO `area_city` VALUES (37, '沈阳市', 210100, 210000, 6);
INSERT INTO `area_city` VALUES (38, '大连市', 210200, 210000, 6);
INSERT INTO `area_city` VALUES (39, '鞍山市', 210300, 210000, 6);
INSERT INTO `area_city` VALUES (40, '抚顺市', 210400, 210000, 6);
INSERT INTO `area_city` VALUES (41, '本溪市', 210500, 210000, 6);
INSERT INTO `area_city` VALUES (42, '丹东市', 210600, 210000, 6);
INSERT INTO `area_city` VALUES (43, '锦州市', 210700, 210000, 6);
INSERT INTO `area_city` VALUES (44, '营口市', 210800, 210000, 6);
INSERT INTO `area_city` VALUES (45, '阜新市', 210900, 210000, 6);
INSERT INTO `area_city` VALUES (46, '辽阳市', 211000, 210000, 6);
INSERT INTO `area_city` VALUES (47, '盘锦市', 211100, 210000, 6);
INSERT INTO `area_city` VALUES (48, '铁岭市', 211200, 210000, 6);
INSERT INTO `area_city` VALUES (49, '朝阳市', 211300, 210000, 6);
INSERT INTO `area_city` VALUES (50, '葫芦岛市', 211400, 210000, 6);
INSERT INTO `area_city` VALUES (51, '长春市', 220100, 220000, 7);
INSERT INTO `area_city` VALUES (52, '吉林市', 220200, 220000, 7);
INSERT INTO `area_city` VALUES (53, '四平市', 220300, 220000, 7);
INSERT INTO `area_city` VALUES (54, '辽源市', 220400, 220000, 7);
INSERT INTO `area_city` VALUES (55, '通化市', 220500, 220000, 7);
INSERT INTO `area_city` VALUES (56, '白山市', 220600, 220000, 7);
INSERT INTO `area_city` VALUES (57, '松原市', 220700, 220000, 7);
INSERT INTO `area_city` VALUES (58, '白城市', 220800, 220000, 7);
INSERT INTO `area_city` VALUES (59, '延边朝鲜族自治州', 222400, 220000, 7);
INSERT INTO `area_city` VALUES (60, '哈尔滨市', 230100, 230000, 8);
INSERT INTO `area_city` VALUES (61, '齐齐哈尔市', 230200, 230000, 8);
INSERT INTO `area_city` VALUES (62, '鸡西市', 230300, 230000, 8);
INSERT INTO `area_city` VALUES (63, '鹤岗市', 230400, 230000, 8);
INSERT INTO `area_city` VALUES (64, '双鸭山市', 230500, 230000, 8);
INSERT INTO `area_city` VALUES (65, '大庆市', 230600, 230000, 8);
INSERT INTO `area_city` VALUES (66, '伊春市', 230700, 230000, 8);
INSERT INTO `area_city` VALUES (67, '佳木斯市', 230800, 230000, 8);
INSERT INTO `area_city` VALUES (68, '七台河市', 230900, 230000, 8);
INSERT INTO `area_city` VALUES (69, '牡丹江市', 231000, 230000, 8);
INSERT INTO `area_city` VALUES (70, '黑河市', 231100, 230000, 8);
INSERT INTO `area_city` VALUES (71, '绥化市', 231200, 230000, 8);
INSERT INTO `area_city` VALUES (72, '大兴安岭地区', 232700, 230000, 8);
INSERT INTO `area_city` VALUES (73, '上海市', 310100, 310000, 9);
INSERT INTO `area_city` VALUES (74, '南京市', 320100, 320000, 10);
INSERT INTO `area_city` VALUES (75, '无锡市', 320200, 320000, 10);
INSERT INTO `area_city` VALUES (76, '徐州市', 320300, 320000, 10);
INSERT INTO `area_city` VALUES (77, '常州市', 320400, 320000, 10);
INSERT INTO `area_city` VALUES (78, '苏州市', 320500, 320000, 10);
INSERT INTO `area_city` VALUES (79, '南通市', 320600, 320000, 10);
INSERT INTO `area_city` VALUES (80, '连云港市', 320700, 320000, 10);
INSERT INTO `area_city` VALUES (81, '淮安市', 320800, 320000, 10);
INSERT INTO `area_city` VALUES (82, '盐城市', 320900, 320000, 10);
INSERT INTO `area_city` VALUES (83, '扬州市', 321000, 320000, 10);
INSERT INTO `area_city` VALUES (84, '镇江市', 321100, 320000, 10);
INSERT INTO `area_city` VALUES (85, '泰州市', 321200, 320000, 10);
INSERT INTO `area_city` VALUES (86, '宿迁市', 321300, 320000, 10);
INSERT INTO `area_city` VALUES (87, '杭州市', 330100, 330000, 11);
INSERT INTO `area_city` VALUES (88, '宁波市', 330200, 330000, 11);
INSERT INTO `area_city` VALUES (89, '温州市', 330300, 330000, 11);
INSERT INTO `area_city` VALUES (90, '嘉兴市', 330400, 330000, 11);
INSERT INTO `area_city` VALUES (91, '湖州市', 330500, 330000, 11);
INSERT INTO `area_city` VALUES (92, '绍兴市', 330600, 330000, 11);
INSERT INTO `area_city` VALUES (93, '金华市', 330700, 330000, 11);
INSERT INTO `area_city` VALUES (94, '衢州市', 330800, 330000, 11);
INSERT INTO `area_city` VALUES (95, '舟山市', 330900, 330000, 11);
INSERT INTO `area_city` VALUES (96, '台州市', 331000, 330000, 11);
INSERT INTO `area_city` VALUES (97, '丽水市', 331100, 330000, 11);
INSERT INTO `area_city` VALUES (98, '合肥市', 340100, 340000, 12);
INSERT INTO `area_city` VALUES (99, '芜湖市', 340200, 340000, 12);
INSERT INTO `area_city` VALUES (100, '蚌埠市', 340300, 340000, 12);
INSERT INTO `area_city` VALUES (101, '淮南市', 340400, 340000, 12);
INSERT INTO `area_city` VALUES (102, '马鞍山市', 340500, 340000, 12);
INSERT INTO `area_city` VALUES (103, '淮北市', 340600, 340000, 12);
INSERT INTO `area_city` VALUES (104, '铜陵市', 340700, 340000, 12);
INSERT INTO `area_city` VALUES (105, '安庆市', 340800, 340000, 12);
INSERT INTO `area_city` VALUES (106, '黄山市', 341000, 340000, 12);
INSERT INTO `area_city` VALUES (107, '滁州市', 341100, 340000, 12);
INSERT INTO `area_city` VALUES (108, '阜阳市', 341200, 340000, 12);
INSERT INTO `area_city` VALUES (109, '宿州市', 341300, 340000, 12);
INSERT INTO `area_city` VALUES (110, '六安市', 341500, 340000, 12);
INSERT INTO `area_city` VALUES (111, '亳州市', 341600, 340000, 12);
INSERT INTO `area_city` VALUES (112, '池州市', 341700, 340000, 12);
INSERT INTO `area_city` VALUES (113, '宣城市', 341800, 340000, 12);
INSERT INTO `area_city` VALUES (114, '福州市', 350100, 350000, 13);
INSERT INTO `area_city` VALUES (115, '厦门市', 350200, 350000, 13);
INSERT INTO `area_city` VALUES (116, '莆田市', 350300, 350000, 13);
INSERT INTO `area_city` VALUES (117, '三明市', 350400, 350000, 13);
INSERT INTO `area_city` VALUES (118, '泉州市', 350500, 350000, 13);
INSERT INTO `area_city` VALUES (119, '漳州市', 350600, 350000, 13);
INSERT INTO `area_city` VALUES (120, '南平市', 350700, 350000, 13);
INSERT INTO `area_city` VALUES (121, '龙岩市', 350800, 350000, 13);
INSERT INTO `area_city` VALUES (122, '宁德市', 350900, 350000, 13);
INSERT INTO `area_city` VALUES (123, '南昌市', 360100, 360000, 14);
INSERT INTO `area_city` VALUES (124, '景德镇市', 360200, 360000, 14);
INSERT INTO `area_city` VALUES (125, '萍乡市', 360300, 360000, 14);
INSERT INTO `area_city` VALUES (126, '九江市', 360400, 360000, 14);
INSERT INTO `area_city` VALUES (127, '新余市', 360500, 360000, 14);
INSERT INTO `area_city` VALUES (128, '鹰潭市', 360600, 360000, 14);
INSERT INTO `area_city` VALUES (129, '赣州市', 360700, 360000, 14);
INSERT INTO `area_city` VALUES (130, '吉安市', 360800, 360000, 14);
INSERT INTO `area_city` VALUES (131, '宜春市', 360900, 360000, 14);
INSERT INTO `area_city` VALUES (132, '抚州市', 361000, 360000, 14);
INSERT INTO `area_city` VALUES (133, '上饶市', 361100, 360000, 14);
INSERT INTO `area_city` VALUES (134, '济南市', 370100, 370000, 15);
INSERT INTO `area_city` VALUES (135, '青岛市', 370200, 370000, 15);
INSERT INTO `area_city` VALUES (136, '淄博市', 370300, 370000, 15);
INSERT INTO `area_city` VALUES (137, '枣庄市', 370400, 370000, 15);
INSERT INTO `area_city` VALUES (138, '东营市', 370500, 370000, 15);
INSERT INTO `area_city` VALUES (139, '烟台市', 370600, 370000, 15);
INSERT INTO `area_city` VALUES (140, '潍坊市', 370700, 370000, 15);
INSERT INTO `area_city` VALUES (141, '济宁市', 370800, 370000, 15);
INSERT INTO `area_city` VALUES (142, '泰安市', 370900, 370000, 15);
INSERT INTO `area_city` VALUES (143, '威海市', 371000, 370000, 15);
INSERT INTO `area_city` VALUES (144, '日照市', 371100, 370000, 15);
INSERT INTO `area_city` VALUES (145, '临沂市', 371300, 370000, 15);
INSERT INTO `area_city` VALUES (146, '德州市', 371400, 370000, 15);
INSERT INTO `area_city` VALUES (147, '聊城市', 371500, 370000, 15);
INSERT INTO `area_city` VALUES (148, '滨州市', 371600, 370000, 15);
INSERT INTO `area_city` VALUES (149, '菏泽市', 371700, 370000, 15);
INSERT INTO `area_city` VALUES (150, '郑州市', 410100, 410000, 16);
INSERT INTO `area_city` VALUES (151, '开封市', 410200, 410000, 16);
INSERT INTO `area_city` VALUES (152, '洛阳市', 410300, 410000, 16);
INSERT INTO `area_city` VALUES (153, '平顶山市', 410400, 410000, 16);
INSERT INTO `area_city` VALUES (154, '安阳市', 410500, 410000, 16);
INSERT INTO `area_city` VALUES (155, '鹤壁市', 410600, 410000, 16);
INSERT INTO `area_city` VALUES (156, '新乡市', 410700, 410000, 16);
INSERT INTO `area_city` VALUES (157, '焦作市', 410800, 410000, 16);
INSERT INTO `area_city` VALUES (158, '濮阳市', 410900, 410000, 16);
INSERT INTO `area_city` VALUES (159, '许昌市', 411000, 410000, 16);
INSERT INTO `area_city` VALUES (160, '漯河市', 411100, 410000, 16);
INSERT INTO `area_city` VALUES (161, '三门峡市', 411200, 410000, 16);
INSERT INTO `area_city` VALUES (162, '南阳市', 411300, 410000, 16);
INSERT INTO `area_city` VALUES (163, '商丘市', 411400, 410000, 16);
INSERT INTO `area_city` VALUES (164, '信阳市', 411500, 410000, 16);
INSERT INTO `area_city` VALUES (165, '周口市', 411600, 410000, 16);
INSERT INTO `area_city` VALUES (166, '驻马店市', 411700, 410000, 16);
INSERT INTO `area_city` VALUES (167, '济源市', 419001, 410000, 16);
INSERT INTO `area_city` VALUES (168, '武汉市', 420100, 420000, 17);
INSERT INTO `area_city` VALUES (169, '黄石市', 420200, 420000, 17);
INSERT INTO `area_city` VALUES (170, '十堰市', 420300, 420000, 17);
INSERT INTO `area_city` VALUES (171, '宜昌市', 420500, 420000, 17);
INSERT INTO `area_city` VALUES (172, '襄阳市', 420600, 420000, 17);
INSERT INTO `area_city` VALUES (173, '鄂州市', 420700, 420000, 17);
INSERT INTO `area_city` VALUES (174, '荆门市', 420800, 420000, 17);
INSERT INTO `area_city` VALUES (175, '孝感市', 420900, 420000, 17);
INSERT INTO `area_city` VALUES (176, '荆州市', 421000, 420000, 17);
INSERT INTO `area_city` VALUES (177, '黄冈市', 421100, 420000, 17);
INSERT INTO `area_city` VALUES (178, '咸宁市', 421200, 420000, 17);
INSERT INTO `area_city` VALUES (179, '随州市', 421300, 420000, 17);
INSERT INTO `area_city` VALUES (180, '恩施土家族苗族自治州', 422800, 420000, 17);
INSERT INTO `area_city` VALUES (181, '仙桃市', 429004, 420000, 17);
INSERT INTO `area_city` VALUES (182, '潜江市', 429005, 420000, 17);
INSERT INTO `area_city` VALUES (183, '天门市', 429006, 420000, 17);
INSERT INTO `area_city` VALUES (184, '神农架林区', 429021, 420000, 17);
INSERT INTO `area_city` VALUES (185, '长沙市', 430100, 430000, 18);
INSERT INTO `area_city` VALUES (186, '株洲市', 430200, 430000, 18);
INSERT INTO `area_city` VALUES (187, '湘潭市', 430300, 430000, 18);
INSERT INTO `area_city` VALUES (188, '衡阳市', 430400, 430000, 18);
INSERT INTO `area_city` VALUES (189, '邵阳市', 430500, 430000, 18);
INSERT INTO `area_city` VALUES (190, '岳阳市', 430600, 430000, 18);
INSERT INTO `area_city` VALUES (191, '常德市', 430700, 430000, 18);
INSERT INTO `area_city` VALUES (192, '张家界市', 430800, 430000, 18);
INSERT INTO `area_city` VALUES (193, '益阳市', 430900, 430000, 18);
INSERT INTO `area_city` VALUES (194, '郴州市', 431000, 430000, 18);
INSERT INTO `area_city` VALUES (195, '永州市', 431100, 430000, 18);
INSERT INTO `area_city` VALUES (196, '怀化市', 431200, 430000, 18);
INSERT INTO `area_city` VALUES (197, '娄底市', 431300, 430000, 18);
INSERT INTO `area_city` VALUES (198, '湘西土家族苗族自治州', 433100, 430000, 18);
INSERT INTO `area_city` VALUES (199, '广州市', 440100, 440000, 19);
INSERT INTO `area_city` VALUES (200, '韶关市', 440200, 440000, 19);
INSERT INTO `area_city` VALUES (201, '深圳市', 440300, 440000, 19);
INSERT INTO `area_city` VALUES (202, '珠海市', 440400, 440000, 19);
INSERT INTO `area_city` VALUES (203, '汕头市', 440500, 440000, 19);
INSERT INTO `area_city` VALUES (204, '佛山市', 440600, 440000, 19);
INSERT INTO `area_city` VALUES (205, '江门市', 440700, 440000, 19);
INSERT INTO `area_city` VALUES (206, '湛江市', 440800, 440000, 19);
INSERT INTO `area_city` VALUES (207, '茂名市', 440900, 440000, 19);
INSERT INTO `area_city` VALUES (208, '肇庆市', 441200, 440000, 19);
INSERT INTO `area_city` VALUES (209, '惠州市', 441300, 440000, 19);
INSERT INTO `area_city` VALUES (210, '梅州市', 441400, 440000, 19);
INSERT INTO `area_city` VALUES (211, '汕尾市', 441500, 440000, 19);
INSERT INTO `area_city` VALUES (212, '河源市', 441600, 440000, 19);
INSERT INTO `area_city` VALUES (213, '阳江市', 441700, 440000, 19);
INSERT INTO `area_city` VALUES (214, '清远市', 441800, 440000, 19);
INSERT INTO `area_city` VALUES (215, '东莞市', 441900, 440000, 19);
INSERT INTO `area_city` VALUES (216, '中山市', 442000, 440000, 19);
INSERT INTO `area_city` VALUES (217, '潮州市', 445100, 440000, 19);
INSERT INTO `area_city` VALUES (218, '揭阳市', 445200, 440000, 19);
INSERT INTO `area_city` VALUES (219, '云浮市', 445300, 440000, 19);
INSERT INTO `area_city` VALUES (220, '南宁市', 450100, 450000, 20);
INSERT INTO `area_city` VALUES (221, '柳州市', 450200, 450000, 20);
INSERT INTO `area_city` VALUES (222, '桂林市', 450300, 450000, 20);
INSERT INTO `area_city` VALUES (223, '梧州市', 450400, 450000, 20);
INSERT INTO `area_city` VALUES (224, '北海市', 450500, 450000, 20);
INSERT INTO `area_city` VALUES (225, '防城港市', 450600, 450000, 20);
INSERT INTO `area_city` VALUES (226, '钦州市', 450700, 450000, 20);
INSERT INTO `area_city` VALUES (227, '贵港市', 450800, 450000, 20);
INSERT INTO `area_city` VALUES (228, '玉林市', 450900, 450000, 20);
INSERT INTO `area_city` VALUES (229, '百色市', 451000, 450000, 20);
INSERT INTO `area_city` VALUES (230, '贺州市', 451100, 450000, 20);
INSERT INTO `area_city` VALUES (231, '河池市', 451200, 450000, 20);
INSERT INTO `area_city` VALUES (232, '来宾市', 451300, 450000, 20);
INSERT INTO `area_city` VALUES (233, '崇左市', 451400, 450000, 20);
INSERT INTO `area_city` VALUES (234, '海口市', 460100, 460000, 21);
INSERT INTO `area_city` VALUES (235, '三亚市', 460200, 460000, 21);
INSERT INTO `area_city` VALUES (236, '三沙市', 460300, 460000, 21);
INSERT INTO `area_city` VALUES (237, '儋州市', 460400, 460000, 21);
INSERT INTO `area_city` VALUES (238, '五指山市', 469001, 460000, 21);
INSERT INTO `area_city` VALUES (239, '琼海市', 469002, 460000, 21);
INSERT INTO `area_city` VALUES (240, '文昌市', 469005, 460000, 21);
INSERT INTO `area_city` VALUES (241, '万宁市', 469006, 460000, 21);
INSERT INTO `area_city` VALUES (242, '东方市', 469007, 460000, 21);
INSERT INTO `area_city` VALUES (243, '定安县', 469021, 460000, 21);
INSERT INTO `area_city` VALUES (244, '屯昌县', 469022, 460000, 21);
INSERT INTO `area_city` VALUES (245, '澄迈县', 469023, 460000, 21);
INSERT INTO `area_city` VALUES (246, '临高县', 469024, 460000, 21);
INSERT INTO `area_city` VALUES (247, '白沙黎族自治县', 469025, 460000, 21);
INSERT INTO `area_city` VALUES (248, '昌江黎族自治县', 469026, 460000, 21);
INSERT INTO `area_city` VALUES (249, '乐东黎族自治县', 469027, 460000, 21);
INSERT INTO `area_city` VALUES (250, '陵水黎族自治县', 469028, 460000, 21);
INSERT INTO `area_city` VALUES (251, '保亭黎族苗族自治县', 469029, 460000, 21);
INSERT INTO `area_city` VALUES (252, '琼中黎族苗族自治县', 469030, 460000, 21);
INSERT INTO `area_city` VALUES (253, '重庆市', 500100, 500000, 22);
INSERT INTO `area_city` VALUES (254, '成都市', 510100, 510000, 23);
INSERT INTO `area_city` VALUES (255, '自贡市', 510300, 510000, 23);
INSERT INTO `area_city` VALUES (256, '攀枝花市', 510400, 510000, 23);
INSERT INTO `area_city` VALUES (257, '泸州市', 510500, 510000, 23);
INSERT INTO `area_city` VALUES (258, '德阳市', 510600, 510000, 23);
INSERT INTO `area_city` VALUES (259, '绵阳市', 510700, 510000, 23);
INSERT INTO `area_city` VALUES (260, '广元市', 510800, 510000, 23);
INSERT INTO `area_city` VALUES (261, '遂宁市', 510900, 510000, 23);
INSERT INTO `area_city` VALUES (262, '内江市', 511000, 510000, 23);
INSERT INTO `area_city` VALUES (263, '乐山市', 511100, 510000, 23);
INSERT INTO `area_city` VALUES (264, '南充市', 511300, 510000, 23);
INSERT INTO `area_city` VALUES (265, '眉山市', 511400, 510000, 23);
INSERT INTO `area_city` VALUES (266, '宜宾市', 511500, 510000, 23);
INSERT INTO `area_city` VALUES (267, '广安市', 511600, 510000, 23);
INSERT INTO `area_city` VALUES (268, '达州市', 511700, 510000, 23);
INSERT INTO `area_city` VALUES (269, '雅安市', 511800, 510000, 23);
INSERT INTO `area_city` VALUES (270, '巴中市', 511900, 510000, 23);
INSERT INTO `area_city` VALUES (271, '资阳市', 512000, 510000, 23);
INSERT INTO `area_city` VALUES (272, '阿坝藏族羌族自治州', 513200, 510000, 23);
INSERT INTO `area_city` VALUES (273, '甘孜藏族自治州', 513300, 510000, 23);
INSERT INTO `area_city` VALUES (274, '凉山彝族自治州', 513400, 510000, 23);
INSERT INTO `area_city` VALUES (275, '贵阳市', 520100, 520000, 24);
INSERT INTO `area_city` VALUES (276, '六盘水市', 520200, 520000, 24);
INSERT INTO `area_city` VALUES (277, '遵义市', 520300, 520000, 24);
INSERT INTO `area_city` VALUES (278, '安顺市', 520400, 520000, 24);
INSERT INTO `area_city` VALUES (279, '毕节市', 520500, 520000, 24);
INSERT INTO `area_city` VALUES (280, '铜仁市', 520600, 520000, 24);
INSERT INTO `area_city` VALUES (281, '黔西南布依族苗族自治州', 522300, 520000, 24);
INSERT INTO `area_city` VALUES (282, '黔东南苗族侗族自治州', 522600, 520000, 24);
INSERT INTO `area_city` VALUES (283, '黔南布依族苗族自治州', 522700, 520000, 24);
INSERT INTO `area_city` VALUES (284, '昆明市', 530100, 530000, 25);
INSERT INTO `area_city` VALUES (285, '曲靖市', 530300, 530000, 25);
INSERT INTO `area_city` VALUES (286, '玉溪市', 530400, 530000, 25);
INSERT INTO `area_city` VALUES (287, '保山市', 530500, 530000, 25);
INSERT INTO `area_city` VALUES (288, '昭通市', 530600, 530000, 25);
INSERT INTO `area_city` VALUES (289, '丽江市', 530700, 530000, 25);
INSERT INTO `area_city` VALUES (290, '普洱市', 530800, 530000, 25);
INSERT INTO `area_city` VALUES (291, '临沧市', 530900, 530000, 25);
INSERT INTO `area_city` VALUES (292, '楚雄彝族自治州', 532300, 530000, 25);
INSERT INTO `area_city` VALUES (293, '红河哈尼族彝族自治州', 532500, 530000, 25);
INSERT INTO `area_city` VALUES (294, '文山壮族苗族自治州', 532600, 530000, 25);
INSERT INTO `area_city` VALUES (295, '西双版纳傣族自治州', 532800, 530000, 25);
INSERT INTO `area_city` VALUES (296, '大理白族自治州', 532900, 530000, 25);
INSERT INTO `area_city` VALUES (297, '德宏傣族景颇族自治州', 533100, 530000, 25);
INSERT INTO `area_city` VALUES (298, '怒江傈僳族自治州', 533300, 530000, 25);
INSERT INTO `area_city` VALUES (299, '迪庆藏族自治州', 533400, 530000, 25);
INSERT INTO `area_city` VALUES (300, '拉萨市', 540100, 540000, 26);
INSERT INTO `area_city` VALUES (301, '日喀则市', 540200, 540000, 26);
INSERT INTO `area_city` VALUES (302, '昌都市', 540300, 540000, 26);
INSERT INTO `area_city` VALUES (303, '林芝市', 540400, 540000, 26);
INSERT INTO `area_city` VALUES (304, '山南市', 540500, 540000, 26);
INSERT INTO `area_city` VALUES (305, '那曲市', 540600, 540000, 26);
INSERT INTO `area_city` VALUES (306, '阿里地区', 542500, 540000, 26);
INSERT INTO `area_city` VALUES (307, '西安市', 610100, 610000, 27);
INSERT INTO `area_city` VALUES (308, '铜川市', 610200, 610000, 27);
INSERT INTO `area_city` VALUES (309, '宝鸡市', 610300, 610000, 27);
INSERT INTO `area_city` VALUES (310, '咸阳市', 610400, 610000, 27);
INSERT INTO `area_city` VALUES (311, '渭南市', 610500, 610000, 27);
INSERT INTO `area_city` VALUES (312, '延安市', 610600, 610000, 27);
INSERT INTO `area_city` VALUES (313, '汉中市', 610700, 610000, 27);
INSERT INTO `area_city` VALUES (314, '榆林市', 610800, 610000, 27);
INSERT INTO `area_city` VALUES (315, '安康市', 610900, 610000, 27);
INSERT INTO `area_city` VALUES (316, '商洛市', 611000, 610000, 27);
INSERT INTO `area_city` VALUES (317, '兰州市', 620100, 620000, 28);
INSERT INTO `area_city` VALUES (318, '嘉峪关市', 620200, 620000, 28);
INSERT INTO `area_city` VALUES (319, '金昌市', 620300, 620000, 28);
INSERT INTO `area_city` VALUES (320, '白银市', 620400, 620000, 28);
INSERT INTO `area_city` VALUES (321, '天水市', 620500, 620000, 28);
INSERT INTO `area_city` VALUES (322, '武威市', 620600, 620000, 28);
INSERT INTO `area_city` VALUES (323, '张掖市', 620700, 620000, 28);
INSERT INTO `area_city` VALUES (324, '平凉市', 620800, 620000, 28);
INSERT INTO `area_city` VALUES (325, '酒泉市', 620900, 620000, 28);
INSERT INTO `area_city` VALUES (326, '庆阳市', 621000, 620000, 28);
INSERT INTO `area_city` VALUES (327, '定西市', 621100, 620000, 28);
INSERT INTO `area_city` VALUES (328, '陇南市', 621200, 620000, 28);
INSERT INTO `area_city` VALUES (329, '临夏回族自治州', 622900, 620000, 28);
INSERT INTO `area_city` VALUES (330, '甘南藏族自治州', 623000, 620000, 28);
INSERT INTO `area_city` VALUES (331, '西宁市', 630100, 630000, 29);
INSERT INTO `area_city` VALUES (332, '海东市', 630200, 630000, 29);
INSERT INTO `area_city` VALUES (333, '海北藏族自治州', 632200, 630000, 29);
INSERT INTO `area_city` VALUES (334, '黄南藏族自治州', 632300, 630000, 29);
INSERT INTO `area_city` VALUES (335, '海南藏族自治州', 632500, 630000, 29);
INSERT INTO `area_city` VALUES (336, '果洛藏族自治州', 632600, 630000, 29);
INSERT INTO `area_city` VALUES (337, '玉树藏族自治州', 632700, 630000, 29);
INSERT INTO `area_city` VALUES (338, '海西蒙古族藏族自治州', 632800, 630000, 29);
INSERT INTO `area_city` VALUES (339, '银川市', 640100, 640000, 30);
INSERT INTO `area_city` VALUES (340, '石嘴山市', 640200, 640000, 30);
INSERT INTO `area_city` VALUES (341, '吴忠市', 640300, 640000, 30);
INSERT INTO `area_city` VALUES (342, '固原市', 640400, 640000, 30);
INSERT INTO `area_city` VALUES (343, '中卫市', 640500, 640000, 30);
INSERT INTO `area_city` VALUES (344, '乌鲁木齐市', 650100, 650000, 31);
INSERT INTO `area_city` VALUES (345, '克拉玛依市', 650200, 650000, 31);
INSERT INTO `area_city` VALUES (346, '吐鲁番市', 650400, 650000, 31);
INSERT INTO `area_city` VALUES (347, '哈密市', 650500, 650000, 31);
INSERT INTO `area_city` VALUES (348, '昌吉回族自治州', 652300, 650000, 31);
INSERT INTO `area_city` VALUES (349, '博尔塔拉蒙古自治州', 652700, 650000, 31);
INSERT INTO `area_city` VALUES (350, '巴音郭楞蒙古自治州', 652800, 650000, 31);
INSERT INTO `area_city` VALUES (351, '阿克苏地区', 652900, 650000, 31);
INSERT INTO `area_city` VALUES (352, '克孜勒苏柯尔克孜自治州', 653000, 650000, 31);
INSERT INTO `area_city` VALUES (353, '喀什地区', 653100, 650000, 31);
INSERT INTO `area_city` VALUES (354, '和田地区', 653200, 650000, 31);
INSERT INTO `area_city` VALUES (355, '伊犁哈萨克自治州', 654000, 650000, 31);
INSERT INTO `area_city` VALUES (356, '塔城地区', 654200, 650000, 31);
INSERT INTO `area_city` VALUES (357, '阿勒泰地区', 654300, 650000, 31);
INSERT INTO `area_city` VALUES (358, '胡杨河市', 659000, 650000, 31);
INSERT INTO `area_city` VALUES (359, '石河子市', 659001, 650000, 31);
INSERT INTO `area_city` VALUES (360, '阿拉尔市', 659002, 650000, 31);
INSERT INTO `area_city` VALUES (361, '图木舒克市', 659003, 650000, 31);
INSERT INTO `area_city` VALUES (362, '五家渠市', 659004, 650000, 31);
INSERT INTO `area_city` VALUES (363, '北屯市', 659005, 650000, 31);
INSERT INTO `area_city` VALUES (364, '铁门关市', 659006, 650000, 31);
INSERT INTO `area_city` VALUES (365, '双河市', 659007, 650000, 31);
INSERT INTO `area_city` VALUES (366, '可克达拉市', 659008, 650000, 31);
INSERT INTO `area_city` VALUES (367, '昆玉市', 659009, 650000, 31);
INSERT INTO `area_city` VALUES (368, '台北市', 710100, 710000, 32);
INSERT INTO `area_city` VALUES (369, '高雄市', 710200, 710000, 32);
INSERT INTO `area_city` VALUES (370, '新北市', 710300, 710000, 32);
INSERT INTO `area_city` VALUES (371, '台中市', 710400, 710000, 32);
INSERT INTO `area_city` VALUES (372, '台南市', 710500, 710000, 32);
INSERT INTO `area_city` VALUES (373, '桃园市', 710600, 710000, 32);
INSERT INTO `area_city` VALUES (374, '基隆市', 719001, 710000, 32);
INSERT INTO `area_city` VALUES (375, '新竹市', 719002, 710000, 32);
INSERT INTO `area_city` VALUES (376, '嘉义市', 719003, 710000, 32);
INSERT INTO `area_city` VALUES (377, '新竹县', 719004, 710000, 32);
INSERT INTO `area_city` VALUES (378, '宜兰县', 719005, 710000, 32);
INSERT INTO `area_city` VALUES (379, '苗栗县', 719006, 710000, 32);
INSERT INTO `area_city` VALUES (380, '彰化县', 719007, 710000, 32);
INSERT INTO `area_city` VALUES (381, '云林县', 719008, 710000, 32);
INSERT INTO `area_city` VALUES (382, '南投县', 719009, 710000, 32);
INSERT INTO `area_city` VALUES (383, '嘉义县', 719010, 710000, 32);
INSERT INTO `area_city` VALUES (384, '屏东县', 719011, 710000, 32);
INSERT INTO `area_city` VALUES (385, '台东县', 719012, 710000, 32);
INSERT INTO `area_city` VALUES (386, '花莲县', 719013, 710000, 32);
INSERT INTO `area_city` VALUES (387, '澎湖县', 719014, 710000, 32);
INSERT INTO `area_city` VALUES (388, '香港', 810000, 810000, 33);
INSERT INTO `area_city` VALUES (389, '澳门', 820000, 820000, 34);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
